Leveled hierarchy is for aggregation reporting where parent values reflect the aggregation points. It is activated as a BI-Blend aggregation control impacting the Star-Schema dimension tables with the creation of Leveled and IsBaseBIBlend column fields. Leveling adds the hierarchy context that is useful in Pivot Grids and custom dashboard reports.
Use the following syntax: TopMember;RestrictMember;Labels;SSLeveled
Example: EUR_MFG;;;SSLeveled
.png "Leveled Hierarchy in Aggregation Controls")
The column fields generated by the SSLeveled property are created to the maximum depth of the hierarchy, starting from the defined parent to the base member. The leveled columns are only created on base members and their ancestors where data is populated in the BI-Blend data table. Levels greater than those containing data are not created.
NOTE: The property is not valid for use on Account and Attribute aggregation controls.
The leveling process generates two field placeholders:
-
XFLeveled : Created only on base-level records for data intersections whose hierarchy is less than the maximum depth.
-
XFStored : Created only on parent-level members. This represents the data intersection of stored-parent values created by the BI-Blend engine
Leveled Hierarchy Processing
The SSLeveled property enables the generation of the hierarchy leveling fields. Efficiency is accomplished by limiting the leveling only to members that contain data in the BI-Blend data table. However, leveling is an additional process used by the BI-Blend Engine which will affect the overall BI-Blend processing time.
